[Bug]: self_management_router.create_tenant “QueryCanceledError: canceling statement due to statement timeout”

Repo: · Issue: #341 Status: Open · Priority: P2 Assignee: Unassigned Labels: bug

Description

Steps to reproduce

Not clear, caused by https://twill-network.slack.com/archives/C07TPN6FCBX/p1746456327733109

But in general it is request to create tenant which failed with Unhandled exception: canceling statement due to statement timeout error.

Expected behavior

No issues, tenant created.

Actual behavior

Error logs:

2025-05-05 21:18:36.159|ERROR|master|fastapi_utils:164|POST http://staging.twillai.com/api/v1/self-management/tenant Unhandled exception: canceling statement due to statement timeout
Traceback (most recent call last):
  File "/app/app/core/fastapi_utils.py", line 122, in run_route_handler
    response = await dependant.call(**values)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/app/api/self_management_router.py", line 150, in create_tenant
    dbprofile_dicts = await DbProfile.insert_return_all(
                      ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...
  File "asyncpg/protocol/protocol.pyx", line 206, in bind_execute
asyncpg.exceptions.QueryCanceledError: canceling statement due to statement timeout

2025-05-05 21:18:36.305|INFO|master|fastapi_utils:304|FINISH POST http://staging.twillai.com/api/v1/self-management/tenant took 120.756: 500 duratio

## Implementation Notes
_Dash adds notes here while working_

## Related
_Link to people, meetings, dependent tickets_